﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsRanking" targetNamespace="http://tempuri.org/dsRanking.xsd" xmlns:mstns="http://tempuri.org/dsRanking.xsd" xmlns="http://tempuri.org/dsRanking.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCrewTypeTableAdapter" GeneratorDataComponentClassName="tblCrewTypeTableAdapter" Name="tblCrewType" UserDataComponentName="tblCrewTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCrewType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCrewType] WHERE (([id] = @Original_id) AND ((@IsNull_cTypeName = 1 AND [cTypeName] IS NULL) OR ([cTypeName] = @Original_cTypeName)) AND ((@IsNull_Prefix = 1 AND [Prefix] IS NULL) OR ([Prefix] = @Original_Prefix)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTypeName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTypeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Prefix" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Prefix" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCrewType] ([cTypeName], [Prefix]) VALUES (@cTypeName, @Prefix);
SELECT id, cTypeName, Prefix FROM tblCrewType WHERE (id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Prefix" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Prefix" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, cTypeName, Prefix FROM dbo.tblCrewType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCrewType] SET [cTypeName] = @cTypeName, [Prefix] = @Prefix WHERE (([id] = @Original_id) AND ((@IsNull_cTypeName = 1 AND [cTypeName] IS NULL) OR ([cTypeName] = @Original_cTypeName)) AND ((@IsNull_Prefix = 1 AND [Prefix] IS NULL) OR ([Prefix] = @Original_Prefix)));
SELECT id, cTypeName, Prefix FROM tblCrewType WHERE (id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Prefix" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Prefix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cTypeName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cTypeName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Prefix" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Prefix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="cTypeName" DataSetColumn="cTypeName" />
              <Mapping SourceColumn="Prefix" DataSetColumn="Prefix" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblRankingTableAdapter" GeneratorDataComponentClassName="tblRankingTableAdapter" Name="tblRanking" UserDataComponentName="tblRankingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRanking" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblRanking] WHERE (([rankID] = @Original_rankID) AND ([nCrewId] = @Original_nCrewId) AND ((@IsNull_dDateIssused = 1 AND [dDateIssused] IS NULL) OR ([dDateIssused] = @Original_dDateIssused)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_rankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateIssused" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateIssused" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateIssused" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dDateIssused" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblRanking] ([rankID], [nCrewId], [dDateIssused]) VALUES (@rankID, @nCrewId, @dDateIssused);
SELECT rankID, nCrewId, dDateIssused FROM tblRanking WHERE (nCrewId = @nCrewId) AND (rankID = @rankID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@rankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateIssused" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dDateIssused" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT rankID, nCrewId, dDateIssused FROM dbo.tblRanking</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblRanking] SET [rankID] = @rankID, [nCrewId] = @nCrewId, [dDateIssused] = @dDateIssused WHERE (([rankID] = @Original_rankID) AND ([nCrewId] = @Original_nCrewId) AND ((@IsNull_dDateIssused = 1 AND [dDateIssused] IS NULL) OR ([dDateIssused] = @Original_dDateIssused)));
SELECT rankID, nCrewId, dDateIssused FROM tblRanking WHERE (nCrewId = @nCrewId) AND (rankID = @rankID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@rankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateIssused" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dDateIssused" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_rankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateIssused" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateIssused" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateIssused" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dDateIssused" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="rankID" DataSetColumn="rankID" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="dDateIssused" DataSetColumn="dDateIssused" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRanking" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCrewID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCrewID" GeneratorSourceName="FillByCrewID" GetMethodModifier="Public" GetMethodName="GetDataByCrewID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCrewID" UserSourceName="FillByCrewID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT top 1 rankID, nCrewId, dDateIssused FROM dbo.tblRanking
where nCrewId=@crewid 
order by dDateIssused  desc</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="crewid" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblRanking" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@crewid" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblRankTableAdapter" GeneratorDataComponentClassName="tblRankTableAdapter" Name="tblRank" UserDataComponentName="tblRankTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblRank] WHERE (([nRankId] = @Original_nRankId) AND ((@IsNull_cRankName = 1 AND [cRankName] IS NULL) OR ([cRankName] = @Original_cRankName)) AND ((@IsNull_nRankLevel = 1 AND [nRankLevel] IS NULL) OR ([nRankLevel] = @Original_nRankLevel)) AND ((@IsNull_cRankDescription = 1 AND [cRankDescription] IS NULL) OR ([cRankDescription] = @Original_cRankDescription)) AND ((@IsNull_iRankType = 1 AND [iRankType] IS NULL) OR ([iRankType] = @Original_iRankType)) AND ((@IsNull_BasicMonthlyWages = 1 AND [BasicMonthlyWages] IS NULL) OR ([BasicMonthlyWages] = @Original_BasicMonthlyWages)) AND ((@IsNull_Overtime_B = 1 AND [Overtime B] IS NULL) OR ([Overtime B] = @Original_Overtime_B)) AND ((@IsNull_SubsisAllowence = 1 AND [SubsisAllowence] IS NULL) OR ([SubsisAllowence] = @Original_SubsisAllowence)) AND ((@IsNull_Overtime_A = 1 AND [Overtime A] IS NULL) OR ([Overtime A] = @Original_Overtime_A)) AND ((@IsNull_Monthly_leave_pay = 1 AND [Monthly leave pay] IS NULL) OR ([Monthly leave pay] = @Original_Monthly_leave_pay)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasicMonthlyWages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_B" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubsisAllowence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_A" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Monthly_leave_pay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblRank] ([cRankName], [nRankLevel], [cRankDescription], [iRankType], [BasicMonthlyWages], [Overtime B], [SubsisAllowence], [Overtime A], [Monthly leave pay]) VALUES (@cRankName, @nRankLevel, @cRankDescription, @iRankType, @BasicMonthlyWages, @Overtime_B, @SubsisAllowence, @Overtime_A, @Monthly_leave_pay);
SELECT nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime B], SubsisAllowence, [Overtime A], [Monthly leave pay] FROM tblRank WHERE (nRankId = SCOPE_IDENTITY()) ORDER BY nRankLevel DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime B], SubsisAllowence, [Overtime A], [Monthly leave pay]
FROM            tblRank
ORDER BY nRankLevel DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblRank] SET [cRankName] = @cRankName, [nRankLevel] = @nRankLevel, [cRankDescription] = @cRankDescription, [iRankType] = @iRankType, [BasicMonthlyWages] = @BasicMonthlyWages, [Overtime B] = @Overtime_B, [SubsisAllowence] = @SubsisAllowence, [Overtime A] = @Overtime_A, [Monthly leave pay] = @Monthly_leave_pay WHERE (([nRankId] = @Original_nRankId) AND ((@IsNull_cRankName = 1 AND [cRankName] IS NULL) OR ([cRankName] = @Original_cRankName)) AND ((@IsNull_nRankLevel = 1 AND [nRankLevel] IS NULL) OR ([nRankLevel] = @Original_nRankLevel)) AND ((@IsNull_cRankDescription = 1 AND [cRankDescription] IS NULL) OR ([cRankDescription] = @Original_cRankDescription)) AND ((@IsNull_iRankType = 1 AND [iRankType] IS NULL) OR ([iRankType] = @Original_iRankType)) AND ((@IsNull_BasicMonthlyWages = 1 AND [BasicMonthlyWages] IS NULL) OR ([BasicMonthlyWages] = @Original_BasicMonthlyWages)) AND ((@IsNull_Overtime_B = 1 AND [Overtime B] IS NULL) OR ([Overtime B] = @Original_Overtime_B)) AND ((@IsNull_SubsisAllowence = 1 AND [SubsisAllowence] IS NULL) OR ([SubsisAllowence] = @Original_SubsisAllowence)) AND ((@IsNull_Overtime_A = 1 AND [Overtime A] IS NULL) OR ([Overtime A] = @Original_Overtime_A)) AND ((@IsNull_Monthly_leave_pay = 1 AND [Monthly leave pay] IS NULL) OR ([Monthly leave pay] = @Original_Monthly_leave_pay)));
SELECT nRankId, cRankName, nRankLevel, cRankDescription, iRankType, BasicMonthlyWages, [Overtime B], SubsisAllowence, [Overtime A], [Monthly leave pay] FROM tblRank WHERE (nRankId = @nRankId) ORDER BY nRankLevel DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankLevel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankLevel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cRankDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cRankDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cRankDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iRankType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BasicMonthlyWages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BasicMonthlyWages" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BasicMonthlyWages" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_B" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_B" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime B" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SubsisAllowence" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SubsisAllowence" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SubsisAllowence" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Overtime_A" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Overtime_A" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Overtime A" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Monthly_leave_pay" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Monthly_leave_pay" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Monthly leave pay" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nRankId" ColumnName="nRankId" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nRankId" DataSetColumn="nRankId" />
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
              <Mapping SourceColumn="nRankLevel" DataSetColumn="nRankLevel" />
              <Mapping SourceColumn="cRankDescription" DataSetColumn="cRankDescription" />
              <Mapping SourceColumn="iRankType" DataSetColumn="iRankType" />
              <Mapping SourceColumn="BasicMonthlyWages" DataSetColumn="BasicMonthlyWages" />
              <Mapping SourceColumn="[Overtime A]" DataSetColumn="Overtime A" />
              <Mapping SourceColumn="[Overtime B]" DataSetColumn="Overtime B" />
              <Mapping SourceColumn="SubsisAllowence" DataSetColumn="SubsisAllowence" />
              <Mapping SourceColumn="Overtime B" DataSetColumn="Overtime B" />
              <Mapping SourceColumn="Overtime A" DataSetColumn="Overtime A" />
              <Mapping SourceColumn="Monthly leave pay" DataSetColumn="Monthly leave pay" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByType" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByType" GeneratorSourceName="FillByType" GetMethodModifier="Public" GetMethodName="GetDataByType" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByType" UserSourceName="FillByType">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BasicMonthlyWages, [Monthly leave pay], [Overtime A], [Overtime B], SubsisAllowence, cRankDescription, cRankName, iRankType, nRankId, nRankLevel FROM tblRank WHERE (iRankType = @rankType)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="rankType" ColumnName="iRankType" DataSourceName="CrewManagment.dbo.tblRank" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@rankType" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="iRankType" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblRank" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetLastedRow" GetMethodModifier="Public" GetMethodName="GetLastedRow" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLastedRow" UserSourceName="GetLastedRow">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT BasicMonthlyWages, [Monthly leave pay], [Overtime A], [Overtime B], SubsisAllowence, cRankDescription, cRankName, iRankType, nRankId, nRankLevel FROM tblRank WHERE (nRankId = (SELECT MAX(nRankId) AS Expr1 FROM tblRank AS tblRank_1))</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsRanking" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsRanking" msprop:Generator_UserDSName="dsRanking">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblCrewType" msprop:Generator_TableClassName="tblCrewTypeDataTable" msprop:Generator_TableVarName="tabletblCrewType" msprop:Generator_TablePropName="tblCrewType" msprop:Generator_RowDeletingName="tblCrewTypeRowDeleting" msprop:Generator_UserTableName="tblCrewType" msprop:Generator_RowChangingName="tblCrewTypeRowChanging" msprop:Generator_RowEvHandlerName="tblCrewTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewTypeRowDeleted" msprop:Generator_RowEvArgName="tblCrewTypeRowChangeEvent" msprop:Generator_RowChangedName="tblCrewTypeRowChanged" msprop:Generator_RowClassName="tblCrewTypeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="cTypeName" msprop:Generator_ColumnVarNameInTable="columncTypeName" msprop:Generator_ColumnPropNameInRow="cTypeName" msprop:Generator_ColumnPropNameInTable="cTypeNameColumn" msprop:Generator_UserColumnName="cTypeName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prefix" msprop:Generator_ColumnVarNameInTable="columnPrefix" msprop:Generator_ColumnPropNameInRow="Prefix" msprop:Generator_ColumnPropNameInTable="PrefixColumn" msprop:Generator_UserColumnName="Prefix" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblRanking" msprop:Generator_TableClassName="tblRankingDataTable" msprop:Generator_TableVarName="tabletblRanking" msprop:Generator_TablePropName="tblRanking" msprop:Generator_RowDeletingName="tblRankingRowDeleting" msprop:Generator_UserTableName="tblRanking" msprop:Generator_RowChangingName="tblRankingRowChanging" msprop:Generator_RowEvHandlerName="tblRankingRowChangeEventHandler" msprop:Generator_RowDeletedName="tblRankingRowDeleted" msprop:Generator_RowEvArgName="tblRankingRowChangeEvent" msprop:Generator_RowChangedName="tblRankingRowChanged" msprop:Generator_RowClassName="tblRankingRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="rankID" msprop:Generator_ColumnVarNameInTable="columnrankID" msprop:Generator_ColumnPropNameInRow="rankID" msprop:Generator_ColumnPropNameInTable="rankIDColumn" msprop:Generator_UserColumnName="rankID" type="xs:int" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateIssused" msprop:Generator_ColumnVarNameInTable="columndDateIssused" msprop:Generator_ColumnPropNameInRow="dDateIssused" msprop:Generator_ColumnPropNameInTable="dDateIssusedColumn" msprop:Generator_UserColumnName="dDateIssused" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblRank" msprop:Generator_TableClassName="tblRankDataTable" msprop:Generator_TableVarName="tabletblRank" msprop:Generator_TablePropName="tblRank" msprop:Generator_RowDeletingName="tblRankRowDeleting" msprop:Generator_UserTableName="tblRank" msprop:Generator_RowChangingName="tblRankRowChanging" msprop:Generator_RowEvHandlerName="tblRankRowChangeEventHandler" msprop:Generator_RowDeletedName="tblRankRowDeleted" msprop:Generator_RowEvArgName="tblRankRowChangeEvent" msprop:Generator_RowChangedName="tblRankRowChanged" msprop:Generator_RowClassName="tblRankRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nRankId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnRankId" msprop:Generator_ColumnPropNameInRow="nRankId" msprop:Generator_ColumnPropNameInTable="nRankIdColumn" msprop:Generator_UserColumnName="nRankId" type="xs:int" />
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankLevel" msprop:Generator_ColumnVarNameInTable="columnnRankLevel" msprop:Generator_ColumnPropNameInRow="nRankLevel" msprop:Generator_ColumnPropNameInTable="nRankLevelColumn" msprop:Generator_UserColumnName="nRankLevel" type="xs:int" minOccurs="0" />
              <xs:element name="cRankDescription" msprop:Generator_ColumnVarNameInTable="columncRankDescription" msprop:Generator_ColumnPropNameInRow="cRankDescription" msprop:Generator_ColumnPropNameInTable="cRankDescriptionColumn" msprop:Generator_UserColumnName="cRankDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iRankType" msprop:Generator_ColumnVarNameInTable="columniRankType" msprop:Generator_ColumnPropNameInRow="iRankType" msprop:Generator_ColumnPropNameInTable="iRankTypeColumn" msprop:Generator_UserColumnName="iRankType" type="xs:int" minOccurs="0" />
              <xs:element name="BasicMonthlyWages" msprop:Generator_ColumnVarNameInTable="columnBasicMonthlyWages" msprop:Generator_ColumnPropNameInRow="BasicMonthlyWages" msprop:Generator_ColumnPropNameInTable="BasicMonthlyWagesColumn" msprop:Generator_UserColumnName="BasicMonthlyWages" type="xs:double" minOccurs="0" />
              <xs:element name="Overtime_x0020_A" msprop:Generator_ColumnVarNameInTable="columnOvertime_A" msprop:Generator_ColumnPropNameInRow="Overtime_A" msprop:Generator_ColumnPropNameInTable="Overtime_AColumn" msprop:Generator_UserColumnName="Overtime A" type="xs:double" minOccurs="0" />
              <xs:element name="Overtime_x0020_B" msprop:Generator_ColumnVarNameInTable="columnOvertime_B" msprop:Generator_ColumnPropNameInRow="Overtime_B" msprop:Generator_ColumnPropNameInTable="Overtime_BColumn" msprop:Generator_UserColumnName="Overtime B" type="xs:double" minOccurs="0" />
              <xs:element name="SubsisAllowence" msprop:Generator_ColumnVarNameInTable="columnSubsisAllowence" msprop:Generator_ColumnPropNameInRow="SubsisAllowence" msprop:Generator_ColumnPropNameInTable="SubsisAllowenceColumn" msprop:Generator_UserColumnName="SubsisAllowence" type="xs:double" minOccurs="0" />
              <xs:element name="Monthly_x0020_leave_x0020_pay" msprop:Generator_ColumnVarNameInTable="columnMonthly_leave_pay" msprop:Generator_ColumnPropNameInRow="Monthly_leave_pay" msprop:Generator_ColumnPropNameInTable="Monthly_leave_payColumn" msprop:Generator_UserColumnName="Monthly leave pay" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrewType" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tblRanking_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblRanking" />
      <xs:field xpath="mstns:rankID" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblRank_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblRank" />
      <xs:field xpath="mstns:nRankId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblRank_tblCrewType" msdata:parent="tblCrewType" msdata:child="tblRank" msdata:parentkey="id" msdata:childkey="iRankType" msprop:Generator_UserChildTable="tblRank" msprop:Generator_ChildPropName="GettblRankRows" msprop:Generator_ParentPropName="tblCrewTypeRow" msprop:Generator_UserRelationName="FK_tblRank_tblCrewType" msprop:Generator_RelationVarName="relationFK_tblRank_tblCrewType" msprop:Generator_UserParentTable="tblCrewType" />
      <msdata:Relationship name="FK_tblRanking_tblRank" msdata:parent="tblRank" msdata:child="tblRanking" msdata:parentkey="nRankId" msdata:childkey="rankID" msprop:Generator_UserChildTable="tblRanking" msprop:Generator_ChildPropName="GettblRankingRows" msprop:Generator_ParentPropName="tblRankRow" msprop:Generator_UserRelationName="FK_tblRanking_tblRank" msprop:Generator_RelationVarName="relationFK_tblRanking_tblRank" msprop:Generator_UserParentTable="tblRank" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>